Bureau of Transportation Statistics¶

Air Travel Consumer Report Period From June 2003 to October 2020¶

Types of Delay¶

1.Carrier Delay¶

2.Late Arrival Delay¶

3.NAS Delay¶

4.Security Delay Cause¶

5.Weather Delay Cause¶

Analysis layer¶

1.Airline¶

2.Airport¶

2.State¶

1.Analysis Airline Layer¶

What is the most carrier agent makeing flights?¶

The Mean of Arrival Flight/1000
1470.2529333333332
Southwest Airlines Co is the most carrier agent makeing flights

What is the most carrier agent makeing delay ?¶

The Mean of Aircraft Delay(min/flight)
53.01640733771036
ExpressJet Airlines Inc is the most carrier agent makeing Delay

What is carrier agent make delay more than def avg Delay?¶

The Mean of def_avg_Delay/1000
5675511.9000122715

2.Analysis Airports Layer¶

What is The Most US Airports had Weather Delay?¶

US Airports distribution by state and Weather Delay info

The Mean of Weather Delay(min/flight)
7.83864917649772
Chicago O Hare International is the Most Airports with weather Delay

Map of US Airports shown the most affected with Weather Delay¶

airport%20distribution%20by%20state%20and%20Weather%20Delay-2.png

What is Most US Airport by LONGITUDE,LATITUDE had Flight Cancelled¶

Flight Cancelled by US Airport Longitude, Latitude

What is Most US Airport had Carrier Delay?¶

Map satellite view of US Airports shown the most affected with Carrier Delay¶

What%20is%20Most%20US%20Airport%20had%20Carrier%20Delay.png

3.Analysis State Layer¶

What is The Most US State had Weather Delay?¶

The Mean of Weather Delay(min/flight) by US State 
39.75564591352922
Florida,California,Texas is the Most US State affected by Weather Delay

Map view of Most US State affected by Weather Delay¶

Florida,California,Texas is the Most US State affected by Weather Delay¶

What%20is%20The%20Most%20US%20State%20had%20Weather%20Delay-2.png

4. Data Visualization¶

Project 3.Communicate Data Findings¶